Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Department, Object Name, Title, Culture, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, City, Classification
Link | rowid ▼ | Object Number | Is Highlight | Is Public Domain | Object ID | Department | Object Name | Title | Culture | Period | Dynasty | Reign | Portfolio | Artist Role | Artist Prefix | Artist Display Name | Artist Display Bio | Artist Suffix | Artist Alpha Sort | Artist Nationality | Artist Begin Date | Artist End Date | Object Date | Object Begin Date | Object End Date | Medium | Dimensions | Credit Line | Geography Type | City | State | County | Country | Region | Subregion | Locale | Locus | Excavation | River | Classification | Rights and Reproduction | Link Resource | Metadata Date | Repository |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2529 | 2529 | 33.120.562 | 0 | 1 | 2724 | American Decorative Arts 1 | Cream pot 284 | Creamer | American 1 | Maker|Retailer 34 | William B. Heyer|Hyde and Nevins | active ca. 1807–22|active ca. 1814–19 | Heyer, William B.|Hyde and Nevins 431 | 1804 |1811 | 1822 |1819 | ca. 1815 | 1813 | 1818 | Silver 2 | 6 1/8 x 6 1/2 x 3 11/16 in. (5.4 x 11.6 x 10 cm); 7 oz. 17 dwt. (244.4 g) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/2724 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
4074 | 4074 | 69.141.3 | 0 | 1 | 4399 | American Decorative Arts 1 | Cream pot 284 | Milk Pot | American 1 | Maker|Retailer 34 | John C. Moore|Ball, Tompkins and Black | ca. 1802–1874|active 1839–51 | Moore, John C. manufacturing silver|Ball, Tompkins and Black 589 | 1799 |1839 | 1874 |1851 | 1850 | 1850 | 1850 | Silver 2 | 8 5/16 x 5 1/16 x 4 3/16 in. (21.1 x 12.8 x 10.6 cm); 15 oz. 16 dwt. (491.6 g) | Gift of Mrs. F. R. Lefferts, 1969 | Made in 1 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/4399 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
4262 | 4262 | 1981.22.1a–c | 0 | 1 | 4598 | American Decorative Arts 1 | Teakettle 309 | Teakettle | American 1 | Maker|Retailer 34 | William Forbes|Ball, Tompkins and Black | baptized 1799, active New York, 1826–63|active 1839–51 | Forbes, William|Ball, Tompkins and Black 621 | 1826 |1839 | 1863 |1851 | ca. 1840 | 1837 | 1840 | Silver and ivory 815 | Overall: 15 3/4 x 9 5/16 in. (40 x 23.7 cm); 68 oz. 4 dwt. (2120.7 g) Body: H. 11 5/8 in. (29.5 cm); 42 oz. 4 dwt. (1312.6 g) Stand: H. 4 1/2 in. (11.4 cm); 21 oz. 10 dwt. (669.3 g) Lamp: H. 2 3/8 x 2 3/4 in. (6 x 7 cm); 4 oz. 9 dwt. (138.8 g) | Gift of Guerdon Holden Nelson, Cyril Irwin Nelson, Nicholas Macy Nelson and Michael Underhill Nelson, in devoted memory of their grandmother, Elinor Irwin Holden, and their mother, Elise Macy Nelson, 1981 | Made in 1 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/4598 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
5461 | 5461 | 33.120.311 | 0 | 1 | 5837 | American Decorative Arts 1 | Cream pot 284 | Creamer | American 1 | Maker|Retailer 34 | Saunders Pitman|Jones, Ball and Poor | 1732–1804|American, 1846–1853 | Pitman, Saunders|Jones, Ball and Poor 817 | American 1 | 1732 |1846 | 1804 |1853 | ca. 1800 | 1795 | 1805 | Silver 2 | Overall: 5 1/16 x 5 3/4 in. (12.9 x 14.6 cm); 6 oz. 8 dwt. (199.2 g) Base: 2 7/16 x 1 7/8 in. (6.2 x 4.8 cm) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | Providence 36 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/5837 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7505 | 7505 | 33.120.561a, b | 0 | 1 | 7993 | American Decorative Arts 1 | Sugar Bowl 111 | Sugar Bowl | American 1 | Maker|Retailer 34 | William B. Heyer|Hyde and Nevins | active ca. 1807–22|active ca. 1814–19 | Heyer, William B.|Hyde and Nevins 431 | 1804 |1811 | 1822 |1819 | ca. 1815 | 1813 | 1818 | Silver 2 | Overall: 7 3/4 x 8 3/8 x 5 1/8 in. (19.7 x 21.3 x 13 cm); 15 oz. 10 dwt. (482 g) Body: H. 6 3/16 in. (15.7 cm); 12 oz. 3 dwt. (377.9 g) Cover: 2 1/8 x 4 9/16 x 3 15/16 in. (5.4 x 11.6 x 10 cm); 3 oz. 7 dwt. (104.1 g) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/7993 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7897 | 7897 | 33.120.560 | 0 | 1 | 8421 | American Decorative Arts 1 | Teapot 26 | Teapot | American 1 | Maker|Retailer 34 | William B. Heyer|Hyde and Nevins | active ca. 1807–22|active ca. 1814–19 | Heyer, William B.|Hyde and Nevins 431 | 1804 |1811 | 1822 |1819 | ca. 1815 | 1813 | 1820 | Silver 2 | 8 5/8 x 11 3/8 x 5 15/16 in. (21.9 x 28.9 x 15.1 cm); 23 oz. 3 dwt. (720.1 g) | Bequest of Alphonso T. Clearwater, 1933 | Made in 1 | New York 3 | United States 3 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/8421 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
16308 | 16308 | 2005.321.3a, b | 0 | 1 | 18874 | American Decorative Arts 1 | Caster 183 | Caster | American 1 | Maker|Retailer 34 | Goodnow & Jenks|Bigelow, Kennard & Co. | 1893–ca. 1905|1830–1922 | Goodnow & Jenks|Bigelow, Kennard & Co. 2505 | 1893 |1830 | 1905 |1922 | ca. 1900 | 1897 | 1903 | Silver 2 | 4 5/16 x 2 3/4 in. (11 x 7 cm) | Gift of David Allen Hanks, in memory of Elizabeth Dixon Hanks, 2005 | Made in 1 | Boston 8 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/18874 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
16309 | 16309 | 2005.321.4a, b | 0 | 1 | 18875 | American Decorative Arts 1 | Caster 183 | Caster | American 1 | Maker|Retailer 34 | Goodnow & Jenks|Bigelow, Kennard & Co. | 1893–ca. 1905|1830–1922 | Goodnow & Jenks|Bigelow, Kennard & Co. 2505 | 1893 |1830 | 1905 |1922 | ca. 1900 | 1897 | 1903 | Silver 2 | 4 5/16 x 2 3/4 in. (11 x 7 cm) | Gift of David Allen Hanks, in memory of Elizabeth Dixon Hanks, 2005 | Made in 1 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/18875 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
94450 | 94450 | 2009.300.4897 | 0 | 0 | 169138 | Costume Institute 8 | Derby 6392 | Derby | American 1 | Maker|Retailer 34 | Berg|Weber & Heilbroner | American|American | Berg|Weber & Heilbroner 7539 | American|American 5 | 1930 | 1930 | 1930 | Wool, silk 16397 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Nathaniel Coleman, 1956 | http://www.metmuseum.org/art/collection/search/169138 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
94646 | 94646 | 2009.300.5118 | 0 | 0 | 169334 | Costume Institute 8 | Cowboy hat 6468 | Cowboy hat | American 1 | Maker|Retailer 34 | Kensington Hats, Inc.|Dave Jones | Kensington Hats, Inc.|Jones Dave 7562 | American|American 5 | ca. 1945 | 1943 | 1947 | Wool, synthetic 19886 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Anonymous gift, 1960 | http://www.metmuseum.org/art/collection/search/169334 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
94670 | 94670 | 2009.300.5143a, b | 0 | 0 | 169358 | Costume Institute 8 | Oxfords 6210 | Oxfords | American 1 | Maker|Retailer 34 | Thomas|Morrison & Shribbs | Thomas|Morrison & Shribbs 7565 | British 7 | 1928–31 | 1928 | 1931 | Leather 732 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Rodman A. Heeren, 1960 | http://www.metmuseum.org/art/collection/search/169358 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
94793 | 94793 | 2009.300.5267 | 0 | 0 | 169481 | Costume Institute 8 | Evening top hat 6678 | Evening top hat | American 1 | Maker|Retailer 34 | Knox|Schumm & Snyder Hat Shop | American | Knox|Schumm & Snyder Hat Shop 7584 | American|American 5 | ca. 1930 | 1928 | 1932 | Silk, hair, wool 20029 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. George E. Brower, 1962 | http://www.metmuseum.org/art/collection/search/169481 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
94802 | 94802 | 2009.300.5276a–c | 0 | 0 | 169490 | Costume Institute 8 | Evening top hat 6678 | Evening top hat | British 6 | Maker|Retailer 34 | Scott & Company|Collins & Fairbanks Co. | British|American, Boston, Massachusetts | Scott & Company|Collins & Fairbanks Co. 7586 | British|American 33 | ca. 1905 | 1903 | 1907 | Fur, silk, leather 20031 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Joseph Warren, 1962 | http://www.metmuseum.org/art/collection/search/169490 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
95085 | 95085 | 2009.300.5552a, b | 0 | 0 | 169773 | Costume Institute 8 | Oxfords 6210 | Oxfords | British 6 | Maker|Retailer 34 | Thomas|Morrison & Shribbs | Thomas|Morrison & Shribbs 7565 | British 7 | ca. 1927 | 1925 | 1929 | Leather 732 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Rodman A. Heeren, 1966 | http://www.metmuseum.org/art/collection/search/169773 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
95800 | 95800 | 2009.300.4084a, b | 0 | 1 | 170488 | Costume Institute 8 | Wedding Shoes 6089 | Wedding shoes | French 7 | Maker|Retailer 34 | Esté|R.W.H. Rogers | French, 1821–1839 | Esté|Rogers R.W.H. 7713 | French 2 | 1821 | 1839 | 1840–49 | 1840 | 1849 | Silk 165 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Chauncey E. Low, 1924 | http://www.metmuseum.org/art/collection/search/170488 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
96918 | 96918 | 2009.300.7169 | 0 | 0 | 174297 | Costume Institute 8 | Bow Tie 6740 | Bow Tie | French 7 | Maker|Retailer 34 | Fortune Cravats|Lord & Taylor | American, founded 1826 | Fortune Cravats|Lord & Taylor 7806 | American 1 | 1826 | 2050 | ca. 1945 | 1943 | 1947 | Silk 165 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Robert Riley, 1961 | http://www.metmuseum.org/art/collection/search/174297 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97711 | 97711 | 2009.300.8067a, b | 0 | 0 | 175092 | Costume Institute 8 | Suit 5876 | Suit | American 1 | Maker|Retailer 34 | Hickey Freeman|F. R. Tripler & Co. | American, founded 1899|American | Hickey Freeman|F. R. Tripler & Co. 7911 | American|American 5 | 1899 | 9999 | 1968 | 1968 | 1968 | Wool 2116 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Milton F. Rosenthal, 1983 | http://www.metmuseum.org/art/collection/search/175092 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97830 | 97830 | 2009.300.8193a, b | 0 | 0 | 175211 | Costume Institute 8 | Suit 5876 | Suit | American 1 | Maker|Retailer 34 | Hickey Freeman|F. R. Tripler & Co. | American, founded 1899|American | Hickey Freeman|F. R. Tripler & Co. 7911 | American|American 5 | 1899 | 9999 | 1967 | 1967 | 1967 | Wool 2116 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Milton F. Rosenthal, 1985 | http://www.metmuseum.org/art/collection/search/175211 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97831 | 97831 | 2009.300.8194a, b | 0 | 0 | 175212 | Costume Institute 8 | Suit 5876 | Suit | American 1 | Maker|Retailer 34 | Hickey Freeman|F. R. Tripler & Co. | American, founded 1899|American | Hickey Freeman|F. R. Tripler & Co. 7911 | American|American 5 | 1899 | 9999 | 1967 | 1967 | 1967 | Wool 2116 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Milton F. Rosenthal, 1985 | http://www.metmuseum.org/art/collection/search/175212 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
117412 | 117412 | 1974.379.1 | 0 | 1 | 206312 | European Sculpture and Decorative Arts 3 | Teapot 26 | Teapot (part of a set) | British, London 222 | Maker|Retailer 34 | Firm of | Paul Storr|Rundell, Bridge and Rundell | British, 1771–1844|British, London, active 1797–1843 | Storr, Paul|Rundell, Bridge and Rundell 11491 | British|British 9 | 1771 |1797 | 1844 |1843 | 1813/14 | 1813 | 1814 | Silver-gilt 20506 | Overall: 5 1/2 × 10 3/8 in. (14 × 26.4 cm) | Gift of Fernanda Munn Kellogg, 1974 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/206312 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
381624 | 381624 | 2013.960.2a–f | 0 | 1 | 629597 | American Decorative Arts 1 | Balance scale 26594 | Balance scale | American 1 | Maker|Retailer 34 | Henry N. Hooper and Company|O.P. Drake | ca. 1831–68|American, 1844–1876 | Hooper and Company Henry N.|Drake, O.P. 49052 | American 1 | 1830 |1844 | 1868 |1876 | ca. 1845–55 | 1840 | 1860 | Brass, steel, and marble 57943 | 31 3/4 × 36 × 10 in. (80.6 × 91.4 × 25.4 cm) | Gift of Mr. and Mrs. Stuart P. Feld, 2013 | Made in 1 | Boston 8 | United States 3 | Metal 1 | http://www.metmuseum.org/art/collection/search/629597 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
423725 | 423725 | 2016.533.9 | 0 | 0 | 702898 | American Decorative Arts 1 | Spoon 78 | Dessert Spoon | American 1 | Maker|Retailer 34 | Hotchkiss & Schreuder|H. & D. Rosenberg | American, ca. 1857–71|American, 1847–84 | Hotchkiss & Schreuder|H & D Rosenberg 54065 | 1857 |1847 | 1871 |1884 | ca. 1867 | 1867 | 1867 | Silver 2 | 7 in., 1.19 Troy Ounces (17.8 cm, 37g) | Gift of D. Frederick Baker from the Baker/Pisano Collection, 2016 | Made in 1 | Syracuse 116 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/702898 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
423728 | 423728 | 2016.533.12 | 0 | 0 | 702901 | American Decorative Arts 1 | Fish Slice 442 | Fish Slice | American 1 | Maker|Retailer 34 | Schulz & Fischer|Hain & Pollard | American, 1868–1887|American, ca. 1865–74 | Schulz & Fischer|Hain & Pollard 54066 | 1868 |1865 | 1887 |1874 | ca. 1872 | 1867 | 1877 | Silver 2 | 12 1/4 in., 3.103 Troy Ounces (31.1 cm, 96.5g) | Gift of D. Frederick Baker from the Baker/Pisano Collection, 2016 | Made in 1 | San Francisco 194 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/702901 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
437072 | 437072 | 2016.618.3a–g, .4 | 0 | 1 | 727148 | European Sculpture and Decorative Arts 3 | Candelabrum and stand 27142 | Six-light candelabrum and stand (one of a pair) | British 6 | Maker|Retailer 34 | Alexis Decaix|Rundell, Bridge and Rundell | British, active 1778–1811|British, London, active 1797–1843 | Decaix, Alexis|Rundell, Bridge and Rundell 55580 | 1778 |1797 | 1811 |1843 | ca. 1802–6 | 1797 | 1807 | Gilt bronze 30 | Overall (candelabrum (.1a–g), confirmed): 29 3/4 × 15 × 13 1/4 in., 42 lb. (75.6 × 38.1 × 33.7 cm, 19.1 kg); Overall (stand (.4), confirmed): 3 1/2 × 14 5/8 × 14 5/8 in. (8.9 × 37.1 × 37.1 cm) | Purchase, Gift of Irwin Untermyer, by exchange, 2016 | Metalwork-Gilt Bronze 323 | http://www.metmuseum.org/art/collection/search/727148 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
456896 | 456896 | 2018.62.58 | 0 | 0 | 771056 | European Sculpture and Decorative Arts 3 | Vase 7 | Vase with Aesthetic Japonisme birds | British 6 | Maker|Retailer 34 | Minton(s)|Bailey, Banks & Biddle | British, Stoke-on-Trent, 1793–present|American, founded Philadelphia, Pennsylvania, 1878 | Minton|Bailey, Banks & Biddle 58477 | 1793 |1878 | 2001 |2050 | 1879 | 1879 | 1879 | Porcelain 109 | Height (approximate): 10 in. (25.4 cm) | Gift of Helene Fortunoff and Robert Grossman, 2017 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/771056 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
CREATE TABLE "MetObjects" ( "Object Number" TEXT, "Is Highlight" INTEGER, "Is Public Domain" INTEGER, "Object ID" INTEGER, "Department" INTEGER, "Object Name" INTEGER, "Title" TEXT, "Culture" INTEGER, "Period" REAL, "Dynasty" INTEGER, "Reign" INTEGER, "Portfolio" INTEGER, "Artist Role" INTEGER, "Artist Prefix" REAL, "Artist Display Name" TEXT, "Artist Display Bio" TEXT, "Artist Suffix" REAL, "Artist Alpha Sort" INTEGER, "Artist Nationality" INTEGER, "Artist Begin Date" TEXT, "Artist End Date" TEXT, "Object Date" TEXT, "Object Begin Date" INTEGER, "Object End Date" INTEGER, "Medium" INTEGER, "Dimensions" TEXT, "Credit Line" TEXT, "Geography Type" INTEGER, "City" INTEGER, "State" INTEGER, "County" INTEGER, "Country" INTEGER, "Region" INTEGER, "Subregion" INTEGER, "Locale" INTEGER, "Locus" INTEGER, "Excavation" INTEGER, "River" INTEGER, "Classification" INTEGER, "Rights and Reproduction" REAL, "Link Resource" TEXT, "Metadata Date" TEXT, "Repository" INTEGER , FOREIGN KEY ("Department") REFERENCES [Department](id), FOREIGN KEY ("Object Name") REFERENCES [Object Name](id), FOREIGN KEY ("Culture") REFERENCES [Culture](id), FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id), FOREIGN KEY ("Reign") REFERENCES [Reign](id), FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id), FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id), FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id), FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id), FOREIGN KEY ("Medium") REFERENCES [Medium](id), FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id), FOREIGN KEY ("City") REFERENCES [City](id), FOREIGN KEY ("State") REFERENCES [State](id), FOREIGN KEY ("County") REFERENCES [County](id), FOREIGN KEY ("Country") REFERENCES [Country](id), FOREIGN KEY ("Region") REFERENCES [Region](id), FOREIGN KEY ("Subregion") REFERENCES [Subregion](id), FOREIGN KEY ("Locale") REFERENCES [Locale](id), FOREIGN KEY ("Locus") REFERENCES [Locus](id), FOREIGN KEY ("Excavation") REFERENCES [Excavation](id), FOREIGN KEY ("River") REFERENCES [River](id), FOREIGN KEY ("Classification") REFERENCES [Classification](id), FOREIGN KEY ("Repository") REFERENCES [Repository](id)); CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department"); CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name"); CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture"); CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty"); CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign"); CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio"); CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role"); CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort"); CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality"); CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium"); CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type"); CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City"); CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State"); CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County"); CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country"); CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region"); CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion"); CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale"); CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus"); CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation"); CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River"); CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification"); CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository"); CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight"); CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain"); CREATE INDEX metobjects_Department ON MetObjects("Department"); CREATE INDEX metobjects_Culture ON MetObjects("Culture"); CREATE INDEX metobjects_Period ON MetObjects("Period"); CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty"); CREATE INDEX metobjects_Medium ON MetObjects("Medium"); CREATE INDEX metobjects_City ON MetObjects("City"); CREATE INDEX metobjects_State ON MetObjects("State"); CREATE INDEX metobjects_County ON MetObjects("County"); CREATE INDEX metobjects_Country ON MetObjects("Country"); CREATE INDEX metobjects_Region ON MetObjects("Region"); CREATE INDEX metobjects_Subregion ON MetObjects("Subregion"); CREATE INDEX metobjects_Locale ON MetObjects("Locale"); CREATE INDEX metobjects_Locus ON MetObjects("Locus"); CREATE INDEX metobjects_Excavation ON MetObjects("Excavation"); CREATE INDEX metobjects_River ON MetObjects("River");